Introduction: In this article we will read on how to hide a table or column in Power BI Web Service. Scenario: I have a Power BI Report with 3 Tables; Orders, People and Returns. I want to hide People table when I am publishing the Power BI Report on Power BI Web Service. Steps: Open … Continue reading Hide table or column in Power BI →

Introduction: In this article, we will learn how to set a default dashboard when you login to Power BI Service. Default Dashboard is termed as ‘Featured Dashboard’ in Power BI. Steps for configuring featured dashboard: Login to Power BI Service Open the Dashboard you need to display when you open Power BI Service. Click ‘Set … Continue reading Featured Dashboard in Power BI →

Introduction: Recently, we encountered an issue while exporting the SSRS Reports to Excel. In CRM, the SSRS Report was displaying the data correctly but for few filter criteria, we were not able to export the Reports to Excel.  On troubleshooting in SQL Data Tools, we found that it was throwing the below error. Error Details: … Continue reading Error while exporting SSRS Reports to Excel →

In this article, we will learn how we can leverage the work hours in Reporting. The calendar entity stores data for customer service calendars and holiday schedules in addition to business. Each calendar is set for a specific time zone. A calendar describes the availability of a service or a resource. Calendars are related to calendarrule records, … Continue reading Work Hours in CRM →

Introduction: In this article, we will learn how to dynamically use Dynamics 365 CRM option set/ CRM picklist in Power BI. As you may be aware that CRM picklist stores Integer value in the backend and not the actual display name. So, whenever you query an entity with picklist fields in Power BI you will … Continue reading CRM Option set in Power BI →

In Power BI, Dynamics 365 is connected using its Web API i.e [organization URI]/api/data/v9.0 Dynamics 365 Web API does not support GET Request for calendarrule entity; because of which Power BI cannot retrieve calendar rule entity details. You can verify by browsing to the URL: [organization URI]/api/data/v9.0/calendarrules Please refer to the screen capture below for … Continue reading Calendar Rule Entity not supported in Power BI →

Introduction: In this article, we will walk through steps on how to authenticate Business Central API using Basic Authentication in Postman Pre-Requisite: Business Central account Business Central API Basic authentication in Postman: In Postman, make a GET request to Business Central base API URL. Base URL: https://api.businesscentral.dynamics.com/v1.0/api/beta For using Basic Authentication, we need to add … Continue reading Explore Business Central API through Postman using Basic Authentication →

Introduction: In this article, we will walk through steps on how to authenticate Business Central API using AAD Authentication in Postman Pre-Requisite: Business Central account Admin Access in Azure Portal Business Central API AAD authentication in Postman: In Postman, make a GET request to Business Central base API URL. Base URL: https://api.businesscentral.dynamics.com/v1.0/api/beta For using successful … Continue reading Explore Business Central API through Postman using AAD Authentication →

Introduction: In this article, we will learn how the Filter changes its default values during Parameter selection in SSRS Reports with Examples. Scenario: I have 4 parameters in my report: Start Date: Default is today’s Date End Date: Default is today’s Date + 60 Days Department: No Default value. Project: Dependent Filter on Department. Once … Continue reading Working of Default Select ALL Parameter Filters in SSRS →

Introduction: Recently, we came across an issue where we were integrating Customer and Sales Order from Dynamics 365 CRM and GP. Customers and Sales Orders were successfully integrated except when Sales Order was created using the Integrated Customers; an error regarding Credit Limit would occur. The TIBCO Cloud Integration GP connector does not support the … Continue reading Using Integrated GP Customers for creating Sales Order through TIBCO Cloud Integration →